import asyncio

import requests as requests
import xlwt
from pyppeteer import launch


def main():
    #写入excel
    book = xlwt.Workbook(encoding='utf-8', style_compression=0)
    sheet = book.add_sheet('懂车帝数据', cell_overwrite_ok=True)

    #渲染各个车型数据
    lenssss = ['暂无报价询底价', '32.5万', '奥迪(进口)', '紧凑型车', '柴油', '2008.01', '2.0T 140马力 L4', '103(140Ps)', '320', '6挡手动',
     '4290x1765x1422', '5门5座两厢车', '', '9.6', '5.1', '', '16581.0元', '4290', '1765', '1422', '2578', '1534', '1506',
     '两厢车', '5', '', '5', '1360', '', '', '', 'CBAB', '1968', '2.0', '涡轮增压', 'L', '4', '4', '', '', '140', '103',
     '4200', '320', '1750-2500', '', '柴油', '0#', '柴油直喷', '', '', '', '6挡手动', '6', '手动变速箱(MT)', '前置前驱', '', '', '', '',
     '承载式', '通风盘式', '实心盘式', '', '205/55 R16', '205/55 R16', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
     '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
     '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
     '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
     '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
     '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '']
    for i in range(0, len(lenssss)):
        sheet.write(2, i+1, lenssss[i])


    book.save('懂车帝奥迪A3.xlsx')




if __name__ == '__main__':
    main()
